Why can't I find a transaction on my account reconciliation?

KB396

Overview

If Journal transactions you expect to see are missing from the Account reconciliation, it may be due to one of the following reasons:

  • The transaction has not been posted and therefore does not exist in the system.
  • The amount differs from what you expect, or it may be included within a larger combined entry (e.g., bulk remittance).
  • The transaction was posted to a different account than expected.
  • The posting date is different from what you believe it to be.
  • The transaction has already been reconciled, but outside of the date range you are reviewing.

Finding a transaction

  1. Press CTRL-SHIFT-R and enter SA1628. Alternatively, you can navigate to General ledger > Report > Journal Transactions and select Detailed transaction listing.

  1. Enter the details of the transaction and select Refresh.
    1. When using the filters, ensure you are not accidentally filtering out the data you are intending to view.
    2. If you are unsure of the posted date or the account details, the best filters to use are the Transaction type and Record # fields. For example, if you are searching for a transaction on Supplier invoice 1234, then you would enter 1234 in the Record # field and select the transaction types: Supplier Invoice and Supplier Invoice (T).

Working out why the transaction is not displaying on the reconciliation

Once you have found the transactions you’re looking for, you can confirm if they have been reconciled to a date that you have not expected.

If your report has a Display style of By transaction, then, at the far right of the report, you will see DR Reconciled and CR Reconciled columns. These show the dates on which the credit and debit sides of the transaction were reconciled.

If your report is being run with a Display style of By account, then you will see a single column called Reconciled. This shows the date on which that account was reconciled for that transaction.

Changing the reconciliation date from SA1628

If the reconciliation date is incorrect (either the date is incorrect, or it is not supposed to be reconciled at all), you are able to update it if you have Administrator permission on the Account Reconciliation function.

  1. Click the date in the Reconciled, DR Reconciled, or CR Reconciled fields (depending on your current Display style).
  2. Enter the correct date in the Reconciliation date field (or leave empty to clear) and select Run.

Did you find this article helpful?

If this article is missing information, ambiguous, or didn’t give you clear instructions, let us know and we will make it better! Please email us and quote the KB# in the top left of this article to let us know why it didn’t help you out and we will point you in the direction of additional information.

Last edit 04/08/25